﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="list.aspx.vb" Inherits="Assignment_2___Prototype.list" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
    <style type="text/css">
        .style2
        {
            width: 86px;
            height: 26px;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <a href="rss.aspx"><img alt="rss" class="style2" src="pictures/rss-logo.jpg" /></a><br />
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        BorderColor="#0099FF" BorderStyle="Solid" CssClass="table" 
        DataKeyNames="UserID" DataSourceID="UserSqlDataSource1" Height="106px" 
        Width="909px" AllowSorting="True">
        <Columns>
            <asp:BoundField DataField="UserID" HeaderText="UserID" InsertVisible="False" 
                ReadOnly="True" SortExpression="UserID" />
            <asp:HyperLinkField DataNavigateUrlFields="UserID" 
                DataNavigateUrlFormatString="details.aspx?UserID={0}" DataTextField="Username" 
                HeaderText="Username" SortExpression="Username" />
            <asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
            <asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" />
            <asp:BoundField DataField="FirstName" HeaderText="FirstName" 
                SortExpression="FirstName" />
            <asp:BoundField DataField="LastName" HeaderText="LastName" 
                SortExpression="LastName" />
            <asp:BoundField DataField="DOB" HeaderText="DOB" SortExpression="DOB" />
        </Columns>
        <HeaderStyle Font-Bold="False" />
    </asp:GridView>
    <asp:SqlDataSource ID="UserSqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:UserConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:UserConnectionString.ProviderName %>" 
        SelectCommand="SELECT [UserID], [Username], [Email], [Title], [FirstName], [LastName], [DOB] FROM [User]">
    </asp:SqlDataSource>
</asp:Content>
